package com.xxxt.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.xxxt.entity.Comment;
import com.xxxt.entity.Company;
import com.xxxt.entity.Practice;
import com.xxxt.entity.Student;

public interface CommentMapper {
	
	List<Practice> findPracticeByStudentAndCompany(@Param("sno") String sno,@Param("companyId") String companyId);
	
	Company findCompany(String companyId);
	
	Student findStudent(String sno);
	
	boolean insertComment(Comment comment);
	
	boolean updateComment(Comment comment);
	
	boolean deleteComment(Comment comment);
	
	Comment findCommentByCommentId(String commentId);
	
	List<Comment> findCommentByCompany(String companyId);
	
	List<Comment> findCommentByCompanyAndSno(@Param("sno") String sno,@Param("companyId") String companyId);
	
	List<Comment> findCommentContentByStudentAndCompany(@Param("sno") String sno,@Param("companyId") String companyId);
	
	
}
